package cj.web.marry.dao;
/*
 *  
 *  
*/
import java.util.List;
import java.util.Map;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;

/**
 * 
 * @author 
 *
 */
@DAO
public interface GameDAO{
	
	@SQL("SELECT id,img,name,type,descs,url FROM Game WHERE deleteFlag=1 and type=:3 ORDER BY updateAt DESC LIMIT :1,:2 ")
    List<Map> query(int start,int length,int type);
	
	@SQL("SELECT count(1) FROM Game WHERE deleteFlag=1 and type=:1 ")
    int querySize(int type);
    
    @SQL("SELECT id,img,name,descs,url FROM Game WHERE id=:1")
    List<Map> queryById(int id);
}